﻿/****************************************************************************************************
 **        Name: InnerException
 ** Description: The exception that casued another exception to be raised.
 ****************************************************************************************************
 ** Revisions
 **  Date        Author               Work Item  Description
 **  ----------  -------------------  ---------  ----------------------------------------------------
 **  11/30/2008  Chad Green             11774    Initial Development
 ****************************************************************************************************/

CREATE TABLE dbo.InnerException
(
	ID          int           NOT NULL IDENTITY(1,1),
	ParentID    int               NULL,
	ExceptionID char(49)      NOT NULL,
	Message     nVarChar(500) NOT NULL,
	Source      nVarChar(250) NOT NULL,
	StackTrace  nVarChar(MAX) NOT NULL,
	TargetSite  nVarChar(250) NOT NULL
)
GO
EXEC sp_addextendedproperty N'MS_Description', N'The exception that casued another exception to be raised.', 'SCHEMA', N'dbo', 'TABLE', N'InnerException', NULL, NULL
GO
EXEC sp_addextendedproperty N'MS_Description', N'System generated identifier for the InnerException record.', 'SCHEMA', N'dbo', 'TABLE', N'InnerException', 'COLUMN', N'ID'
GO
EXEC sp_addextendedproperty N'MS_Description', N'Foreign Key - Identifier of the inner exception this exception is below.', 'SCHEMA', N'dbo', 'TABLE', N'InnerException', 'COLUMN', N'ParentID'
GO
EXEC sp_addextendedproperty N'MS_Description', N'Foreign Key - Identifier of the parent exception record.', 'SCHEMA', N'dbo', 'TABLE', N'InnerException', 'COLUMN', N'ExceptionID'
GO
EXEC sp_addextendedproperty N'MS_Description', N'The message describing the exception.', 'SCHEMA', N'dbo', 'TABLE', N'InnerException', 'COLUMN', N'Message'
GO
EXEC sp_addextendedproperty N'MS_Description', N'The name of the application or the option that causes the exception.', 'SCHEMA', N'dbo', 'TABLE', N'InnerException', 'COLUMN', N'Source'
GO
EXEC sp_addextendedproperty N'MS_Description', N'Representation of the frames on the call stack at the time the current exception was thrown.', 'SCHEMA', N'dbo', 'TABLE', N'InnerException', 'COLUMN', N'StackTrace'
GO
EXEC sp_addextendedproperty N'MS_Description', N'The method that throws the exception.', 'SCHEMA', N'dbo', 'TABLE', N'InnerException', 'COLUMN', N'TargetSite'
GO